﻿CREATE TABLE [dbo].[t_PaymentInput] (
    [ID]            INT             IDENTITY (1, 1) NOT NULL,
    [LoanID]        INT             NOT NULL,
    [Amount]        NUMERIC (18, 2) NOT NULL,
    [DatePaid]      DATETIME        NOT NULL,
    [PrincipalPart] NUMERIC (18, 2) NULL,
    [InterestPart]  NUMERIC (18, 2) NULL,
    [LateFeePart]   NUMERIC (18, 2) NULL,
    [NSFFeePart]    NUMERIC (18, 2) NULL,
    [PaymentID]     INT             NULL,
    [StatusID]      INT             NULL,
    [InputUser]     VARCHAR (32)    NOT NULL,
    [InputDate]     DATETIME        NOT NULL,
    [WaterFallID]   TINYINT         NOT NULL
);

